Still struggling - controlled access section formula is the culprit

HCL Notes/Domino 8.5 Forum (includes Notes Traveler)

Subject:

I still need ideas on this one. I found that a controlled access section was the culprit in producing the error. I can remove the section or change the formula - but managment won't allow it. They want a SYSTEMATIC way that USERS can avert the error and successfully print without DESIGNER intervention!

Here's the formula:

@Trim(@If(@IsNewDoc & @IsDocBeingLoaded; "noone"; @If(VoucherStatus = "Waiting Approval"; SendTo; "") : "[VoucherAdmin]"))

As you can see, it sometimes resolves to "noone"... which is obviously a problem. However, this is in an archive, so everything has been settled on these documents for quite some time. Even when the user is in the [VoucherAdmin] role with manager access, the dreaded error occurs.

I'm thinking that even if I create an agent that will correct the problem on one application, there are 20 more apps that all have this error popping up and like I told management, I can't know until I open the database in Designer what the problem is. The formula that is puking clearly is going to be different in each case.

Any thoughts here? Since we are just wanting to print all these to PDF so that the database may be eliminated, I would prefer to just make the change in Designer to correct the formula causing the error so that the users can do their own PDF exports, then proceed with the elimination of these applications. Yes, it would involve 20 or so design changes, but they wouldn't be time-consuming. How would YOU communicate that to management who won't allow design changes in order to resolve a widespread error?

THANKS!!!

Trish

Feedback response number WEBB8WDT27 created by ~Umberto Quetwegenoopsi on 07/20/2012